﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet" targetNamespace="http://tempuri.org/DataSet.xsd" xmlns:mstns="http://tempuri.org/DataSet.xsd" xmlns="http://tempuri.org/DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ClubSiteDB" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ClubSiteDB (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ClubSiteDB.ConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberInfoTableAdapter" GeneratorDataComponentClassName="MemberInfoTableAdapter" GeneratorDataComponentInterfaceName="IMemberInfoTableAdapter" Name="MemberInfo" UserDataComponentName="MemberInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ClubSiteDB (Web.config)" DbObjectName="dbo.MemberInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetMemberList" GetMethodModifier="Public" GetMethodName="GetMemberList" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetMemberList" UserSourceName="GetMemberList">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [MemberInfo] WHERE (([memberid] = @Original_memberid))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [MemberInfo] ([memberid], [address], [phone], [firstname], [lastname]) VALUES (@memberid, @address, @phone, @firstname, @lastname);
SELECT memberid, address, phone, firstname, lastname, DATALENGTH(avatar) AS AvatarSize FROM MemberInfo WHERE (memberid = @memberid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@firstname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lastname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT memberid, address, phone, firstname, lastname, DATALENGTH(avatar) AS AvatarSize FROM MemberInfo</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [MemberInfo] SET [memberid] = @memberid, [address] = @address, [phone] = @phone, [firstname] = @firstname, [lastname] = @lastname WHERE (([memberid] = @Original_memberid));
SELECT memberid, address, phone, firstname, lastname, DATALENGTH(avatar) AS AvatarSize FROM MemberInfo WHERE (memberid = @memberid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@phone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="phone" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@firstname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lastname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastname" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="phone" DataSetColumn="phone" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
              <Mapping SourceColumn="firstname" DataSetColumn="firstname" />
              <Mapping SourceColumn="lastname" DataSetColumn="lastname" />
              <Mapping SourceColumn="AvatarSize" DataSetColumn="AvatarSize" />
              <Mapping SourceColumn="memberid" DataSetColumn="memberid" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ClubSiteDB (Web.config)" DbObjectName="dbo.MemberInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetMember" GetMethodModifier="Public" GetMethodName="GetMember" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetMember" UserSourceName="GetMember1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT DATALENGTH(avatar) AS AvatarSize, address, firstname, lastname, memberid, phone FROM MemberInfo WHERE (memberid = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="memberid" DataSourceName="[D:\Documents and Settings\samsp\Desktop\clubsite project\Club site\App_Data\clubsite.mdf].dbo.MemberInfo" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@id" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MemberInfo1TableAdapter" GeneratorDataComponentClassName="MemberInfo1TableAdapter" GeneratorDataComponentInterfaceName="IMemberImageTableAdapter" Name="MemberInfo1" UserDataComponentName="MemberInfo1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ClubSiteDB (Web.config)" DbObjectName="dbo.MemberInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="GetData">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [MemberInfo] WHERE (([memberid] = @Original_memberid))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [MemberInfo] ([memberid], [avatar]) VALUES (@memberid, @avatar);
SELECT memberid, avatar FROM MemberInfo WHERE (memberid = @memberid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@avatar" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="avatar" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT memberid, avatar FROM MemberInfo WHERE (memberid = @memberid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="memberid" ColumnName="memberid" DataSourceName="[D:\Documents and Settings\samsp\Desktop\clubsite project\Club site\App_Data\clubsite.mdf].dbo.MemberInfo" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [MemberInfo] SET [memberid] = @memberid, [avatar] = @avatar WHERE (([memberid] = @Original_memberid));
SELECT memberid, avatar FROM MemberInfo WHERE (memberid = @memberid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@avatar" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="avatar" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_memberid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="memberid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="avatar" DataSetColumn="avatar" />
              <Mapping SourceColumn="memberid" DataSetColumn="memberid" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SiteSettingsTableAdapter" GeneratorDataComponentClassName="SiteSettingsTableAdapter" Name="SiteSettings" UserDataComponentName="SiteSettingsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ClubSiteDB (Web.config)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetSiteSettings" GetMethodModifier="Public" GetMethodName="GetSiteSettings" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetSiteSettings" UserSourceName="GetSiteSettings">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [SiteThemes] ([Theme]) VALUES (@Expr1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Expr1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Expr1" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     SiteThemes.Theme, SiteSettings.Theme AS SiteThemeID
FROM         SiteSettings INNER JOIN
                      SiteThemes ON SiteSettings.Theme = SiteThemes.ThemeID</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Theme" DataSetColumn="Theme" />
              <Mapping SourceColumn="SiteThemeID" DataSetColumn="SiteThemeID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet" msprop:Generator_DataSetName="DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="MemberInfo" msprop:Generator_UserTableName="MemberInfo" msprop:Generator_RowDeletedName="MemberInfoRowDeleted" msprop:Generator_RowChangedName="MemberInfoRowChanged" msprop:Generator_RowClassName="MemberInfoRow" msprop:Generator_RowChangingName="MemberInfoRowChanging" msprop:Generator_RowEvArgName="MemberInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="MemberInfoRowChangeEventHandler" msprop:Generator_TableClassName="MemberInfoDataTable" msprop:Generator_TableVarName="tableMemberInfo" msprop:Generator_RowDeletingName="MemberInfoRowDeleting" msprop:Generator_TablePropName="MemberInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phone" msprop:Generator_UserColumnName="phone" msprop:Generator_ColumnPropNameInRow="phone" msprop:Generator_ColumnVarNameInTable="columnphone" msprop:Generator_ColumnPropNameInTable="phoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="photo" msprop:Generator_UserColumnName="photo" msprop:Generator_ColumnPropNameInRow="photo" msprop:Generator_ColumnVarNameInTable="columnphoto" msprop:Generator_ColumnPropNameInTable="photoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="firstname" msprop:Generator_UserColumnName="firstname" msprop:Generator_ColumnVarNameInTable="columnfirstname" msprop:Generator_ColumnPropNameInRow="firstname" msprop:Generator_ColumnPropNameInTable="firstnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastname" msprop:Generator_UserColumnName="lastname" msprop:Generator_ColumnVarNameInTable="columnlastname" msprop:Generator_ColumnPropNameInRow="lastname" msprop:Generator_ColumnPropNameInTable="lastnameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AvatarSize" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AvatarSize" msprop:Generator_ColumnVarNameInTable="columnAvatarSize" msprop:Generator_ColumnPropNameInRow="AvatarSize" msprop:Generator_ColumnPropNameInTable="AvatarSizeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="memberid" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="memberid" msprop:Generator_ColumnVarNameInTable="columnmemberid" msprop:Generator_ColumnPropNameInRow="memberid" msprop:Generator_ColumnPropNameInTable="memberidColumn" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MemberInfo1" msprop:Generator_UserTableName="MemberInfo1" msprop:Generator_RowDeletedName="MemberInfo1RowDeleted" msprop:Generator_RowChangedName="MemberInfo1RowChanged" msprop:Generator_RowClassName="MemberInfo1Row" msprop:Generator_RowChangingName="MemberInfo1RowChanging" msprop:Generator_RowEvArgName="MemberInfo1RowChangeEvent" msprop:Generator_RowEvHandlerName="MemberInfo1RowChangeEventHandler" msprop:Generator_TableClassName="MemberInfo1DataTable" msprop:Generator_TableVarName="tableMemberInfo1" msprop:Generator_RowDeletingName="MemberInfo1RowDeleting" msprop:Generator_TablePropName="MemberInfo1">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="avatar" msprop:Generator_UserColumnName="avatar" msprop:Generator_ColumnVarNameInTable="columnavatar" msprop:Generator_ColumnPropNameInRow="avatar" msprop:Generator_ColumnPropNameInTable="avatarColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="memberid" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="memberid" msprop:Generator_ColumnVarNameInTable="columnmemberid" msprop:Generator_ColumnPropNameInRow="memberid" msprop:Generator_ColumnPropNameInTable="memberidColumn" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SiteSettings" msprop:Generator_UserTableName="SiteSettings" msprop:Generator_RowDeletedName="SiteSettingsRowDeleted" msprop:Generator_RowChangedName="SiteSettingsRowChanged" msprop:Generator_RowClassName="SiteSettingsRow" msprop:Generator_RowChangingName="SiteSettingsRowChanging" msprop:Generator_RowEvArgName="SiteSettingsRowChangeEvent" msprop:Generator_RowEvHandlerName="SiteSettingsRowChangeEventHandler" msprop:Generator_TableClassName="SiteSettingsDataTable" msprop:Generator_TableVarName="tableSiteSettings" msprop:Generator_RowDeletingName="SiteSettingsRowDeleting" msprop:Generator_TablePropName="SiteSettings">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Theme" msprop:Generator_UserColumnName="Theme" msprop:Generator_ColumnPropNameInRow="Theme" msprop:Generator_ColumnVarNameInTable="columnTheme" msprop:Generator_ColumnPropNameInTable="ThemeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SiteThemeID" msprop:Generator_UserColumnName="SiteThemeID" msprop:Generator_ColumnPropNameInRow="SiteThemeID" msprop:Generator_ColumnVarNameInTable="columnSiteThemeID" msprop:Generator_ColumnPropNameInTable="SiteThemeIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MemberInfo" />
      <xs:field xpath="mstns:memberid" />
    </xs:unique>
    <xs:unique name="MemberInfo1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MemberInfo1" />
      <xs:field xpath="mstns:memberid" />
    </xs:unique>
  </xs:element>
</xs:schema>